Range searching

When searching for numerical values within an index, these operators allow you to specify a range values within which to search.

Specifies an alphabetic, numeric or date range to be searched. For example:

A123 TO A456

...will find "A123, A124, A125" ... and so on to "A456".

Note: for the TO operator to be used for dates, the Intelligent Date Handling options must be selected for the index.

Search for a numeric range greater than or equal to the specified value. For example:

GE 1000

...will find "1000, 1001, 1002, 1003 ... 59001"

Search for a numeric range less than or equal to the specified value. For example:

LE 1000

...will find "1000, 999, 998, 997 ... -59001"

For increased accuracy when searching for numeric values, select the Intelligent Number Handling option when creating your Perceptive Search index.